Microsoft's Python in Excel is designed as an alternative to Excel's formula language, not VBA, and integrates Jupyter Notebook cells into the grid. It is not ideal for beginners due to its non-interactive data analysis and challenging diagnostics pane. However, it's still pretty useful for computationally intensive tasks, AI applications, advanced visualizations, and time-series analysis.
Friday, June 14, 2024Python in Excel is now generally available for Windows users of Microsoft 365 Business and Enterprise. The feature makes it possible to seamlessly combine Python and Excel analytics within the same workbook. Python in Excel keeps data private by preventing Python code from knowing who users are and opening workbooks from the internet in further isolation within their own separate containers. The data does not persist in the Microsoft Cloud. This page provides examples of what is now possible with the integration.